package jpa.entitys.promis.construction;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the COST_BOQ database table.
 * 
 */
@Entity
@Table(name="COST_BOQ")
@NamedQueries({
    @NamedQuery(name = "CostBoq.findAll", query = " SELECT c FROM CostBoq c "),
    @NamedQuery(name = "CostBoq.findById", query = " SELECT c FROM CostBoq c WHERE c.id = :Id "),
    @NamedQuery(name = "CostBoq.findBySapPoNo", query = " SELECT c FROM CostBoq c WHERE c.syncExternalRefNo = :syncExternalRefNo And c.status = :status "),
    @NamedQuery(name = "CostBoq.findByStaging", query = " SELECT c FROM CostBoq c WHERE c.syncIsstaging = :syncIsstaging")
})
public class CostBoq extends jpa.entitys.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@EmbeddedId
	private CostBoqPK id;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACTIVITY_CODE")
	private String activityCode;

	@Column(name="ACTUAL_QUANTITY")
	private BigDecimal actualQuantity;

	@Temporal(TemporalType.DATE)
	@Column(name="BOQ_DATE")
	private Date boqDate;

	@Column(name="BOQ_ID")
	private String boqId;

	@Column(name="BOQ_TYPE")
	private String boqType;

	@Column(name="BUDGET_TYPE")
	private String budgetType;

	@Column(name="BUILDING_PHASE")
	private String buildingPhase;

	@Column(name="CONS_LABOUR")
	private BigDecimal consLabour;

	@Column(name="CONS_MATERIAL")
	private BigDecimal consMaterial;

	@Column(name="CONTRACTOR_CODE")
	private String contractorCode;

	@Column(name="CONTRACTOR_LABOUR")
	private BigDecimal contractorLabour;

	@Column(name="CONTRACTOR_MATERIAL")
	private BigDecimal contractorMaterial;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Temporal(TemporalType.DATE)
	@Column(name="CREATED_ON")
	private Date createdOn;

	@Temporal(TemporalType.DATE)
	@Column(name="DATE_FROM")
	private Date dateFrom;

	@Temporal(TemporalType.DATE)
	@Column(name="DATE_TO")
	private Date dateTo;

	@Column(name="DEPARTMENT_CODE")
	private String departmentCode;

	private String description;

	@Column(name="DEVELOPER_LABOUR")
	private BigDecimal developerLabour;

	@Column(name="DEVELOPER_MATERIAL")
	private BigDecimal developerMaterial;

	@Column(name="ESTIMATE_LABOUR")
	private BigDecimal estimateLabour;

	@Column(name="ESTIMATE_MATERIAL")
	private BigDecimal estimateMaterial;

	@Column(name="FROM_BOQ_CODE")
	private String fromBoqCode;

	@Column(name="FROM_BOQ_REV")
	private BigDecimal fromBoqRev;

	@Column(name="FROM_REF_BOQ_CODE")
	private String fromRefBoqCode;

	@Column(name="LABOUR_RATE")
	private BigDecimal labourRate;

	@Column(name="LAST_UPD_BY")
	private String lastUpdBy;

	@Temporal(TemporalType.DATE)
	@Column(name="LAST_UPD_ON")
	private Date lastUpdOn;

	@Column(name="LINK_FILE_ID")
	private String linkFileId;

	@Column(name="LINK_ID")
	private String linkId;

	@Column(name="MATERIAL_RATE")
	private BigDecimal materialRate;

	@Column(name="OVERHEAD_LABOUR")
	private BigDecimal overheadLabour;

	@Column(name="OVERHEAD_MATERIAL")
	private BigDecimal overheadMaterial;

	@Column(name="OVERHEAD_PCT")
	private BigDecimal overheadPct;

	@Column(name="PHASE_CODE")
	private String phaseCode;

	@Column(name="PREPARED_BY")
	private String preparedBy;

	private BigDecimal quantity;

	@Column(name="REF_BOQ_CODE")
	private String refBoqCode;

	@Column(name="REF_NO")
	private BigDecimal refNo;

	@Column(name="REF_SERIES")
	private String refSeries;

	@Column(name="REF_TYPE")
	private String refType;

	private String remarks;

	@Column(name="REQUESTED_BY")
	private String requestedBy;

	@Column(name="SELECT_CONTRACTOR")
	private String selectContractor;

	@Column(name="SEQ_NO")
	private BigDecimal seqNo;

	private String status;

	@Column(name="SUB_ACTIVITY_CODE")
	private String subActivityCode;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

	@Temporal(TemporalType.DATE)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_EXTERNAL_REF_KEY")
	private String syncExternalRefKey;

	@Column(name="SYNC_EXTERNAL_REF_NO")
	private String syncExternalRefNo;

	@Column(name="SYNC_ISSTAGING")
	private String syncIsstaging;

	@Column(name="SYNC_ISSYNC")
	private String syncIssync;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

	@Temporal(TemporalType.DATE)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="SYS_FILE_NAME")
	private String sysFileName;

	@Column(name="TAX_AMOUNT")
	private BigDecimal taxAmount;

	@Column(name="TAX_LABOUR")
	private BigDecimal taxLabour;

	@Column(name="TAX_MATERIAL")
	private BigDecimal taxMaterial;

	@Column(name="TAX_RATE")
	private BigDecimal taxRate;

	@Column(name="TAX_TYPE")
	private String taxType;

	@Column(name="TOTAL_CONS")
	private BigDecimal totalCons;

	@Column(name="TOTAL_CONTRACTOR")
	private BigDecimal totalContractor;

	@Column(name="TOTAL_COST")
	private BigDecimal totalCost;

	@Column(name="TOTAL_DEVELOPER")
	private BigDecimal totalDeveloper;

	@Column(name="TOTAL_ESTIMATE")
	private BigDecimal totalEstimate;

	@Column(name="TOTAL_LABOUR")
	private BigDecimal totalLabour;

	@Column(name="TOTAL_MATERIAL")
	private BigDecimal totalMaterial;

	@Column(name="TOTAL_OVERHEAD")
	private BigDecimal totalOverhead;

	@Column(name="TOTAL_RATE")
	private BigDecimal totalRate;

	private String um;

	@Column(name="UNIT_ID")
	private BigDecimal unitId;

	@Column(name="UNIT_NUMBER")
	private String unitNumber;

	@Column(name="VOUCHER_NO")
	private BigDecimal voucherNo;

	@Column(name="VOUCHER_SERIES")
	private String voucherSeries;

	@Column(name="VOUCHER_TYPE")
	private String voucherType;

	@Column(name="ZONE_CODE")
	private String zoneCode;

	public CostBoq() {
	}

	public CostBoqPK getId() {
		return this.id;
	}

	public void setId(CostBoqPK id) {
		this.id = id;
	}

	public String getActivityCode() {
		return this.activityCode;
	}

	public void setActivityCode(String activityCode) {
		this.activityCode = activityCode;
	}

	public BigDecimal getActualQuantity() {
		return this.actualQuantity;
	}

	public void setActualQuantity(BigDecimal actualQuantity) {
		this.actualQuantity = actualQuantity;
	}

	public Date getBoqDate() {
		return this.boqDate;
	}

	public void setBoqDate(Date boqDate) {
		this.boqDate = boqDate;
	}

	public String getBoqId() {
		return this.boqId;
	}

	public void setBoqId(String boqId) {
		this.boqId = boqId;
	}

	public String getBoqType() {
		return this.boqType;
	}

	public void setBoqType(String boqType) {
		this.boqType = boqType;
	}

	public String getBudgetType() {
		return this.budgetType;
	}

	public void setBudgetType(String budgetType) {
		this.budgetType = budgetType;
	}

	public String getBuildingPhase() {
		return this.buildingPhase;
	}

	public void setBuildingPhase(String buildingPhase) {
		this.buildingPhase = buildingPhase;
	}

	public BigDecimal getConsLabour() {
		return this.consLabour;
	}

	public void setConsLabour(BigDecimal consLabour) {
		this.consLabour = consLabour;
	}

	public BigDecimal getConsMaterial() {
		return this.consMaterial;
	}

	public void setConsMaterial(BigDecimal consMaterial) {
		this.consMaterial = consMaterial;
	}

	public String getContractorCode() {
		return this.contractorCode;
	}

	public void setContractorCode(String contractorCode) {
		this.contractorCode = contractorCode;
	}

	public BigDecimal getContractorLabour() {
		return this.contractorLabour;
	}

	public void setContractorLabour(BigDecimal contractorLabour) {
		this.contractorLabour = contractorLabour;
	}

	public BigDecimal getContractorMaterial() {
		return this.contractorMaterial;
	}

	public void setContractorMaterial(BigDecimal contractorMaterial) {
		this.contractorMaterial = contractorMaterial;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public Date getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(Date createdOn) {
		this.createdOn = createdOn;
	}

	public Date getDateFrom() {
		return this.dateFrom;
	}

	public void setDateFrom(Date dateFrom) {
		this.dateFrom = dateFrom;
	}

	public Date getDateTo() {
		return this.dateTo;
	}

	public void setDateTo(Date dateTo) {
		this.dateTo = dateTo;
	}

	public String getDepartmentCode() {
		return this.departmentCode;
	}

	public void setDepartmentCode(String departmentCode) {
		this.departmentCode = departmentCode;
	}

	public String getDescription() {
		return this.description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public BigDecimal getDeveloperLabour() {
		return this.developerLabour;
	}

	public void setDeveloperLabour(BigDecimal developerLabour) {
		this.developerLabour = developerLabour;
	}

	public BigDecimal getDeveloperMaterial() {
		return this.developerMaterial;
	}

	public void setDeveloperMaterial(BigDecimal developerMaterial) {
		this.developerMaterial = developerMaterial;
	}

	public BigDecimal getEstimateLabour() {
		return this.estimateLabour;
	}

	public void setEstimateLabour(BigDecimal estimateLabour) {
		this.estimateLabour = estimateLabour;
	}

	public BigDecimal getEstimateMaterial() {
		return this.estimateMaterial;
	}

	public void setEstimateMaterial(BigDecimal estimateMaterial) {
		this.estimateMaterial = estimateMaterial;
	}

	public String getFromBoqCode() {
		return this.fromBoqCode;
	}

	public void setFromBoqCode(String fromBoqCode) {
		this.fromBoqCode = fromBoqCode;
	}

	public BigDecimal getFromBoqRev() {
		return this.fromBoqRev;
	}

	public void setFromBoqRev(BigDecimal fromBoqRev) {
		this.fromBoqRev = fromBoqRev;
	}

	public String getFromRefBoqCode() {
		return this.fromRefBoqCode;
	}

	public void setFromRefBoqCode(String fromRefBoqCode) {
		this.fromRefBoqCode = fromRefBoqCode;
	}

	public BigDecimal getLabourRate() {
		return this.labourRate;
	}

	public void setLabourRate(BigDecimal labourRate) {
		this.labourRate = labourRate;
	}

	public String getLastUpdBy() {
		return this.lastUpdBy;
	}

	public void setLastUpdBy(String lastUpdBy) {
		this.lastUpdBy = lastUpdBy;
	}

	public Date getLastUpdOn() {
		return this.lastUpdOn;
	}

	public void setLastUpdOn(Date lastUpdOn) {
		this.lastUpdOn = lastUpdOn;
	}

	public String getLinkFileId() {
		return this.linkFileId;
	}

	public void setLinkFileId(String linkFileId) {
		this.linkFileId = linkFileId;
	}

	public String getLinkId() {
		return this.linkId;
	}

	public void setLinkId(String linkId) {
		this.linkId = linkId;
	}

	public BigDecimal getMaterialRate() {
		return this.materialRate;
	}

	public void setMaterialRate(BigDecimal materialRate) {
		this.materialRate = materialRate;
	}

	public BigDecimal getOverheadLabour() {
		return this.overheadLabour;
	}

	public void setOverheadLabour(BigDecimal overheadLabour) {
		this.overheadLabour = overheadLabour;
	}

	public BigDecimal getOverheadMaterial() {
		return this.overheadMaterial;
	}

	public void setOverheadMaterial(BigDecimal overheadMaterial) {
		this.overheadMaterial = overheadMaterial;
	}

	public BigDecimal getOverheadPct() {
		return this.overheadPct;
	}

	public void setOverheadPct(BigDecimal overheadPct) {
		this.overheadPct = overheadPct;
	}

	public String getPhaseCode() {
		return this.phaseCode;
	}

	public void setPhaseCode(String phaseCode) {
		this.phaseCode = phaseCode;
	}

	public String getPreparedBy() {
		return this.preparedBy;
	}

	public void setPreparedBy(String preparedBy) {
		this.preparedBy = preparedBy;
	}

	public BigDecimal getQuantity() {
		return this.quantity;
	}

	public void setQuantity(BigDecimal quantity) {
		this.quantity = quantity;
	}

	public String getRefBoqCode() {
		return this.refBoqCode;
	}

	public void setRefBoqCode(String refBoqCode) {
		this.refBoqCode = refBoqCode;
	}

	public BigDecimal getRefNo() {
		return this.refNo;
	}

	public void setRefNo(BigDecimal refNo) {
		this.refNo = refNo;
	}

	public String getRefSeries() {
		return this.refSeries;
	}

	public void setRefSeries(String refSeries) {
		this.refSeries = refSeries;
	}

	public String getRefType() {
		return this.refType;
	}

	public void setRefType(String refType) {
		this.refType = refType;
	}

	public String getRemarks() {
		return this.remarks;
	}

	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}

	public String getRequestedBy() {
		return this.requestedBy;
	}

	public void setRequestedBy(String requestedBy) {
		this.requestedBy = requestedBy;
	}

	public String getSelectContractor() {
		return this.selectContractor;
	}

	public void setSelectContractor(String selectContractor) {
		this.selectContractor = selectContractor;
	}

	public BigDecimal getSeqNo() {
		return this.seqNo;
	}

	public void setSeqNo(BigDecimal seqNo) {
		this.seqNo = seqNo;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSubActivityCode() {
		return this.subActivityCode;
	}

	public void setSubActivityCode(String subActivityCode) {
		this.subActivityCode = subActivityCode;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncExternalRefKey() {
		return this.syncExternalRefKey;
	}

	public void setSyncExternalRefKey(String syncExternalRefKey) {
		this.syncExternalRefKey = syncExternalRefKey;
	}

	public String getSyncExternalRefNo() {
		return this.syncExternalRefNo;
	}

	public void setSyncExternalRefNo(String syncExternalRefNo) {
		this.syncExternalRefNo = syncExternalRefNo;
	}

	public String getSyncIsstaging() {
		return this.syncIsstaging;
	}

	public void setSyncIsstaging(String syncIsstaging) {
		this.syncIsstaging = syncIsstaging;
	}

	public String getSyncIssync() {
		return this.syncIssync;
	}

	public void setSyncIssync(String syncIssync) {
		this.syncIssync = syncIssync;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getSysFileName() {
		return this.sysFileName;
	}

	public void setSysFileName(String sysFileName) {
		this.sysFileName = sysFileName;
	}

	public BigDecimal getTaxAmount() {
		return this.taxAmount;
	}

	public void setTaxAmount(BigDecimal taxAmount) {
		this.taxAmount = taxAmount;
	}

	public BigDecimal getTaxLabour() {
		return this.taxLabour;
	}

	public void setTaxLabour(BigDecimal taxLabour) {
		this.taxLabour = taxLabour;
	}

	public BigDecimal getTaxMaterial() {
		return this.taxMaterial;
	}

	public void setTaxMaterial(BigDecimal taxMaterial) {
		this.taxMaterial = taxMaterial;
	}

	public BigDecimal getTaxRate() {
		return this.taxRate;
	}

	public void setTaxRate(BigDecimal taxRate) {
		this.taxRate = taxRate;
	}

	public String getTaxType() {
		return this.taxType;
	}

	public void setTaxType(String taxType) {
		this.taxType = taxType;
	}

	public BigDecimal getTotalCons() {
		return this.totalCons;
	}

	public void setTotalCons(BigDecimal totalCons) {
		this.totalCons = totalCons;
	}

	public BigDecimal getTotalContractor() {
		return this.totalContractor;
	}

	public void setTotalContractor(BigDecimal totalContractor) {
		this.totalContractor = totalContractor;
	}

	public BigDecimal getTotalCost() {
		return this.totalCost;
	}

	public void setTotalCost(BigDecimal totalCost) {
		this.totalCost = totalCost;
	}

	public BigDecimal getTotalDeveloper() {
		return this.totalDeveloper;
	}

	public void setTotalDeveloper(BigDecimal totalDeveloper) {
		this.totalDeveloper = totalDeveloper;
	}

	public BigDecimal getTotalEstimate() {
		return this.totalEstimate;
	}

	public void setTotalEstimate(BigDecimal totalEstimate) {
		this.totalEstimate = totalEstimate;
	}

	public BigDecimal getTotalLabour() {
		return this.totalLabour;
	}

	public void setTotalLabour(BigDecimal totalLabour) {
		this.totalLabour = totalLabour;
	}

	public BigDecimal getTotalMaterial() {
		return this.totalMaterial;
	}

	public void setTotalMaterial(BigDecimal totalMaterial) {
		this.totalMaterial = totalMaterial;
	}

	public BigDecimal getTotalOverhead() {
		return this.totalOverhead;
	}

	public void setTotalOverhead(BigDecimal totalOverhead) {
		this.totalOverhead = totalOverhead;
	}

	public BigDecimal getTotalRate() {
		return this.totalRate;
	}

	public void setTotalRate(BigDecimal totalRate) {
		this.totalRate = totalRate;
	}

	public String getUm() {
		return this.um;
	}

	public void setUm(String um) {
		this.um = um;
	}

	public BigDecimal getUnitId() {
		return this.unitId;
	}

	public void setUnitId(BigDecimal unitId) {
		this.unitId = unitId;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public BigDecimal getVoucherNo() {
		return this.voucherNo;
	}

	public void setVoucherNo(BigDecimal voucherNo) {
		this.voucherNo = voucherNo;
	}

	public String getVoucherSeries() {
		return this.voucherSeries;
	}

	public void setVoucherSeries(String voucherSeries) {
		this.voucherSeries = voucherSeries;
	}

	public String getVoucherType() {
		return this.voucherType;
	}

	public void setVoucherType(String voucherType) {
		this.voucherType = voucherType;
	}

	public String getZoneCode() {
		return this.zoneCode;
	}

	public void setZoneCode(String zoneCode) {
		this.zoneCode = zoneCode;
	}

}